from applications.extensions import db


class SptLand(db.Model):
    """
    省平台发布的成交公告信息
    """
    __tablename__ = 'spt_land'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 设置主键, 默认自增
    dealLandCode = db.Column(db.String(256))
    unifiedDealCode = db.Column(db.String(256))
    landCode = db.Column(db.String(256))
    landUsage = db.Column(db.String(256))
    landPosition = db.Column(db.String(256))
    lendingName = db.Column(db.String(256))
    dataTimeStamp = db.Column(db.String(256))
    dealAnnouncementGuid = db.Column(db.String(256))
    landProjectName = db.Column(db.String(256))
    landUrl = db.Column(db.String(256))
    publishingTime = db.Column(db.String(256))
    ZYID = db.Column(db.String(256))